Sort data in a chart
You can sort category and series data in a chart that is based on a PivotTable list, database table, or query.
- Do one of the following:
- If you want to sort numerical data in a series, click the series or a series point within the series.
- If you want to sort items in a field alphabetically, click the category or series field, or click a category axis label or legend entry.
- Do one of the following:
- Click Sort Ascending
or Sort Descending
on the toolbar. - If you have a stacked bar, stacked area, or stacked column chart, and you want to sort numerically based on the height of the entire stacked value rather than just one series, right-click the series or point, point to Sort, and then click Ascending By Total or Descending By Total.